package com.bigevent.bigevent.mapper;

import com.bigevent.bigevent.entity.Category;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @author yangxudong
 * @description:
 * @date 2024/2/10 11:35
 */
@Mapper
public interface CategoryMapper {
    @Insert("insert into category (category_name, category_alias, create_user, create_time, update_time) values " +
            "(#{categoryName}, #{categoryAlias}, #{createUser}, #{createTime}, #{updateTime})")
    void save(Category category);

    @Select("select * from category where create_user = #{userId}")
    List<Category> getCategoryList(Integer userId);

    @Select("select * from category where id = #{id}")
    Category getCategoryDetail(Integer id);

    @Update("update category set category_name = #{categoryName}, category_alias = #{categoryAlias}, update_time = now() where id = #{id}")
    void updateCategory(Integer id, String categoryName, String categoryAlias);

    @Delete("delete from category where id = #{id}")
    void deleteCategory(Integer id);
}
